import json
from models import BaseModels
from sqlalchemy import Column, BigInteger, DateTime, String, ForeignKey, Integer, Boolean


class Images(BaseModels):
    __tablename__ = 'images'
    id = Column(BigInteger, autoincrement=True, primary_key=True, unique=True, nullable=False)
    time = Column(DateTime, index=True, comment="记录创建时间")
    ft_id = Column(Integer, ForeignKey("facility.id", ondelete='CASCADE'), index=True, comment="设备ID")
    sequence = Column(String(64), index=True, comment="产品序列SN")
    path = Column(String(256), comment="记录创建时间")
    isdel = Column(Boolean, comment="是否删除了")


